# -*- coding = utf-8 -*-
# @Time : 2021/7/16 9:22
# @Author : 龙王赘婿_彪少
# @File : testSqlite2.py
# @Software: PyCharm

import sqlite3

conn = sqlite3.connect("test.db")

print("成功打开数据库")

c = conn.cursor()

sql = '''
    insert into company(id, name, age, address, salary)
    values (1, '小刘', 26, "长沙", 11000),
    (2, '耗耗', 24, "安徽", 9000),
    (3, '刘林', 21, "济南", 1000),
    (4, '小伟', 19, "上海", 300);
'''
# 执行SQL语句
c.execute(sql)

# 提交
conn.commit()
# 关闭
conn.close()

print("插入")